
--------------------------------------------------------------------
--Nombre:	SP_ActualizarTransferenciaActivos
--Objetivo: Actualizar registros a la tabla TransferenciaActivos
--Creacion    : TISI(GOS) 20130226
--------------------------------------------------------------------
CREATE PROCEDURE SP_ActualizarTransferenciaActivos
(

  @IDTransfer bigint,
  @NroTransfer varchar(15),
  @MtvoTransfer varchar(250),
  @FecTransfer datetime,
  @UsuGestTrans varchar(15),
  @DestRespTrans varchar(15),
  @EstadoTransAct int,
  @UsuReg varchar(20),
  @FecReg datetime,
  @TermCnxReg varchar(50),
  @UsuMod varchar(20),
  @fecMod datetime,
  @TermCnxMod varchar(50),
  @IDEmp int
)
AS
BEGIN
  UPDATE TransferenciaActivos
  SET
  IDTransfer = @IDTransfer,
    NroTransfer = @NroTransfer,
    MtvoTransfer = @MtvoTransfer,
    FecTransfer = @FecTransfer,
    UsuGestTrans = @UsuGestTrans,
    DestRespTrans = @DestRespTrans,
    EstadoTransAct = @EstadoTransAct,
    UsuReg = @UsuReg,
    FecReg = @FecReg,
    TermCnxReg = @TermCnxReg,
    UsuMod = @UsuMod,
    fecMod = @fecMod,
    TermCnxMod = @TermCnxMod,
    IDEmp = @IDEmp   
 WHERE
 IDTransfer = @IDTransfer
END
GO
  